302 Found

Found

The document has moved here.

excel

Syndicate content

If you have recently upgraded to Windows 7 and Office 2010, attempting to open QuickBase file attachments saved in earlier versions (97-2003) of Excel, Word, or PowerPoint may produce this error. To fix the problem:

January 9th, 2012 - 10:01 AM
Preparing Excel for Import
Preparing Excel for Import
October 25th, 2009 - 1:10 PM

This would occur if the spreadsheet's or database's CSV (comma separated values) parser is substandard. Excel comes with an excellent CSV parser that knows how to deal with hard returns (aka line breaks, paragraph markers, etc.) that are embedded within the contents of a field.

February 5th, 2009 - 6:02 PM

1. I have a time of day field set up as military time but when it exports to Excel it converts to normal time and adds AM/PM.

For example, 18:00 exports as 6:00 PM.

2. I have a duration field that is exporting differently than on the view.

For example, 2:30 exports as 2.5 hours.

February 5th, 2009 - 6:02 PM

Most QuickBase data will export seamlessly into Microsoft Excel. However, there are some cases when data is lost or displayed with the incorrect formatting.

One example is exporting a 5-digit zip code stored in a text field. When displayed in Excel, any leading zeroes in the zip code are lost. Similar problems can happen when exporting ID numbers, etc.

February 5th, 2009 - 6:02 PM

'Append Only' fields that have the "Show the name and date on their own line" setting turned on do not export to Excel correctly because they contain the leading dashes. Data gets cut off because Excel sees the leading dash and reads it as a numeric field which has a limited size.

February 5th, 2009 - 6:02 PM

There are issues in some Microsoft Internet Explorer and Microsoft Office configurations that can cause problems with downloads. We've seen the issue with all types of Microsoft Office documents and with PDF files. The issue can affect all QuickBase downloads including file attachments, exporting to a spreadsheet, and custom pages.

February 5th, 2009 - 6:02 PM

If your CSV file has a column in it that maps to the key field of the table then all you have to do is import the CSV file into QuickBase. Please read the following help topic:

https://www.quickbase.com/help/importing_data.html

February 5th, 2009 - 6:02 PM
302 Found

Found

The document has moved here.