Issue with conversion to csv

Hi,

Our client will load a csv to Anaplan where we will compute the scorecard base on the dates on their transactions. However, we notice something the contract number column which is a general format in excel becomes scientific format once it is in csv. Please see attachment. We can change it back to the format that we want to but we need to always check it before loading. Is there a way for the client not to check the format of the csv all the time.

Thanks in advance.

Regards,

Format_in_excel_42718.docx

Accepted answers

jesse_wilson

Hi @Jsdeloria21 ,

The issue you're facing is due to converting from XLS to CSV. The latter doesn't have cell format data, so when you re-open the file in Excel, the program does its best to figure out which format to use for the data.

When importing to Anaplan, this shouldn't matter because the data is correct, it's just a matter of how Excel is presenting it to you.

Regards

jesse_wilson

Ultimately, yes the issue is in Excel. Without having cell format data, it's is presenting the data to you in the best possible way it can determine.

All comments

jesse_wilson

Hi @Jsdeloria21 ,

When importing to Anaplan, this shouldn't matter because the data is correct, it's just a matter of how Excel is presenting it to you.

Regards

Jsdeloria21

Hi Jesse,

Appreciate the response. That is where we have a problem the result is correct but the presentation, the contract number is a key line item and they would want to view it the same way in excel but excel is changing the view. We can change it back if we change the format in the csv file. So is this an excel problem?

jesse_wilson

Ultimately, yes the issue is in Excel. Without having cell format data, it's is presenting the data to you in the best possible way it can determine.

Jsdeloria21

Hi Jesse,

Thanks for the clarification

Regards,

nathan.fowler

You can create an export/import process within Anaplan. Ideally we always want to plan within Anaplan but I have created export/import process.

Export
- File Type: CSV
- Layout: Grid
- Omit Summary
- Include Empty
- Action Name: Export [What you want to export] template
- Process Name: EXPORT: [What you want to export] template
Import
- Action Name: Import [What you want to import]
- Process Name: IMPORT: [What you want to import]
- Time: Periods Y-M

FYI, you'll probably get a date error when you set up the action. However, once you run the process end to end the data loads with no errors. This is pretty finicky and you may experience some errors.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…