Solutions
Services

Client Help Center

FAQ Clients Projects and orders

Clients

How do I configure bulk-upload XLS files?

Friday, August 27, 2021 12:52 PM

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

ColumnNameDescription
1 | ATitle
  • Required field
  • Title of the order
2 | BKeywords
  • Optional field
  • Separate several keyword with "|"
  • Density per keyword can be added as "(1:2)"
  • Example: Keyword 1 (1:2) | Keyword 2 (2:3)
3 | CReference-ID
  • Optional field
  • Can be used for external IDs e.g. CRM, ERP 
4 | DWord count min.
  • Required field
  • Minimum 30 words
5 | EWord count max.
  • Required field
6 | FKeyword density min.
  • Optional field
  • Applied for all keywords if not set per keyword.
7 | GKeyword density max.
  • Optional field
  • Applied for all keywords if not set per keyword
8 | HQuality level
  • Required field
  • See table below
9 | I Processing / Days 
  • Required field
  • 1- 4 days 
10 | JText type ID 
  • Required field
  • See table below
11 | KText topic ID
  • Required field
  • See table below
12 | LDetailed order description
  • Optional field 
  • Is added to the end of the briefing
  • Can be formatted as HTML
13 | MURL
  • Optional field
  • Is added to the end of the briefing
  • Can be used to link a product page, etc..

14 | NKeyword counting 
  • Required field
  • Density settings
    • 0 = relative (in % of total words)
    • 1 = absolute number
15 | OFlexendings
  • Required field
  • Flexendings settings
    • 0 = not allowed
    • 1 = allowed

16 | PStopwords
  • Required field
  • Stopwords settings
    • 0 = not allowed
    • 1 = allowed


Quality Level IDs (column 8 / H)

  • 110 = Junior Linguist  
  • 120 = Linguist    
  • 130 = Senior Linguist
  • 140 = Expert Linguist
  • 150 = Technical expert Linguist

Text type ID: (column 10 / J)

  • 1503 : Advertising text
  • 1701 : B2B text
  • 1702 : Blog
  • 1488 : Brand description
  • 1486 : Category description
  • 1562: Destination description
  • 1543 : E-books & whitepaper 
  • 1381 : Guidebooks & how-to texts
  • 1380 : Lexicon & glossary
  • 1493 : Other
  • 1484 : Promotions & offers
  • 1483 : Portraits & profiles
  • 1480 : Press release
  • 1487 : Product descriptions
  • 1492 : Rewriting
  • 1491 : Transcreation 

Text topic ID: (column 11 / K)

  • 1563 : Accomodations
  • 1580 : Adult content
  • 1526 : Apparel & accessoires
  • 1463 : Cars & trucks
  • 1522 : Cosmetics & Beauty
  • 1420 : Education & culture 
  • 1546 : Electronics & software 
  • 1600 : Energy production 
  • 1402 : Finance & insurance
  • 1301 : Fitness & sports 
  • 1322 : Food, drinks & cooking
  • 1523 : Furniture & decoration
  • 1481 : Gaming & gambling
  • 1524 : Gardening & FYI 
  • 1528 : Health & wellness
  • 1541 : Internet & programming 
  • 1441 : Law
  • 1323 : Luxury goods 
  • 1527 : Music, TV series, movies 
  • 1485 : Online & mobile marketing 
  • 1700 : Other
  • 1561 : Places of interest
  • 1461 : Pets & animals 
  • 1560 : Travelling