Log In

Log In



Not registered yet?


Reset password Activation link

Issues With Excel Import Formatting

See how you can fix excel import issues. Just use OpenOffice in order to save with right formatting

We have decided to do a blog post about this topic due to the increasing amount of issues that users are experiencing when uploading from Excel to QuintaDB.

 

Excel has been adding decimal points in the number columns and alterations to our time feature that are unseen until after it is uploaded.

 

I have included instructions below on how to prevent this.

   

Step 1: Go to http://www.openoffice.org/

 

Step 2: Download the version pertaining to your operating system and install it.

 

Step 3: Open your Excel file WITH the new Open Office program (Right click on it and select "Open with". See the screenshot below:

 

Excel

 

Step 4: Let the file open and then click "Save as" in the top left corner. 

   

Step 5: Select the folder or location you want to keep your file and then in the drop down for file type, select "text CSV(.csv)". See screenshot:

   

Excel2

 

Step 6: A message will appear letting you know that the some of the information may not be able to be saved in CSV format. Click the "Keep current format" box. Please see screenshot:

 

Excel3

 

Step 7: A window will open. In the "Character set" dropdown, select "Unicode (UTF-8). It should default with a comma (,) as the default "Field delimiter" and with qutoation marks (") as the default "Text Delimiter". It should also default with "Save cell content as shown" checked. These settings are fine and do not need to be changed. Click "OK". Please see screenshot:

 

Excel4

 

Step 8: A warning will appear letting you know that it only saved the active sheet. IMPORTANT - If you have multiple sheets within your workbook that need to be uploaded to QuintaDB you ill need to repeat this process for all of them. Please see screenshot:

 

Excel5

 

Step 9: Upload that file to QuintaDB the same way you would any other file.

 

We hope this helps solve the mystery of the additional text and bad formatting.

 

Thanks for using QuintaDB!


Please, login to QuintaDB to be able to post comments
Share the discussion in the social networks: