Client Help Center

Can I receive my invoices to a defined email address?

Clients > Billing, Accounting and Payment

How do I configure bulk-upload XLS files?

Modified on: December 6, 2021 at 11:10 am

Explanation

You can place orders via an XLS-files. Each column in the data file represents an attribute of a single order. Each line represents a single order. All uploaded orders are placed in the system. Publishing of the orders needs to be confirmed in the system.

You can find the correct bulk-upload file template at the bottom of this page.

Important notes

The first line of the XLS must contain the version number in the first column (no order!. Please always check for the latest version)
Briefing text in HTML format in column 12 | L must be included (Failure to upload the briefing in HTML will result in your briefing being cut short, and writers will have problems meeting your requirements.)

File structure

Column	Name	Description
1 \| A	Title	Required fieldTitle of the order
2 \| B	Keywords	Optional fieldSeparate several keyword with "\|"Density per keyword can be added as "(1:2)"Example: Keyword 1 (1:2) \| Keyword 2 (2:3)
3 \| C	Reference-ID	Optional fieldCan be used for external IDs e.g. CRM, ERP
4 \| D	Word count min.	Required field Minimum 30 words
5 \| E	Word count max.	Required field
6 \| F	Keyword density min.	Optional fieldApplied for all keywords if not set per keyword.
7 \| G	Keyword density max.	Optional fieldApplied for all keywords if not set per keyword
8 \| H	Quality level	Required fieldSee table below
9 \| I	Processing / Days	Required field1- 4 days
10 \| J	Text type ID	Required fieldSee table below
11 \| K	Text topic ID	Required field See table below
12 \| L	Detailed order description	Optional field Is added to the end of the briefingCan be formatted as HTML
13 \| M	URL	Optional fieldIs added to the end of the briefingCan be used to link a product page, etc..
14 \| N	Keyword counting	Required fieldDensity settings0 = relative (in % of total words)1 = absolute number
15 \| O	Flexendings	Required fieldFlexendings settings0 = not allowed1 = allowed
16 \| P	Stopwords	Required fieldStopwords settings0 = not allowed1 = allowed